set hive.exec.dynamic.partition=true;--动态分区
set hive.exec.dynamic.partition.mode=nonstrict;
set hive.exec.max.dynamic.partitions=400;--每天生成 91 个分区
set hive.exec.max.dynamic.partitions.pernode=400;--每天生成 91 个分区
insert overwrite table jms_dwd.dwd_yl_meeting_video_upload_dt partition (dt)
select
ID
,VIDEO_TIME
,TITLE
,DES
,COMMIT_TIME
,APP_ACCOUNT
,APP_ACCOUNT_NAME
,NETWORK_NAME
,NETWORK_CODE
,NETWORK_ID
,VIDEO_CONTENT
,dt
from jms_ods.yl_meeting_video_upload
where dt='{{ execution_date | cst_ds }}'
distribute by dt,10;
